System and method for improved searching across multiple databases

ABSTRACT

A system for database access comprising a plurality of databases, each database having a plurality of defined data fields and a mapping system coupled to the plurality of databases, the mapping system configured to create an algorithmic relationship between a plurality of first fields of a plurality of first databases, and a corresponding field of a plurality of second fields of a plurality of second databases.

RELATED APPLICATIONS

The present application claims priority to and benefit of U.S.Provisional Patent Application No. 62/754,243, filed Nov. 1, 2018, andU.S. Provisional Patent Application No. 62/827,378, filed Apr. 1, 2019,each of which are hereby incorporated by reference for all purposes asif set forth herein in their entirety.

TECHNICAL FIELD

The present disclosure relates generally to searching databases, andmore specifically to a system and method for improved searching acrossmultiple databases.

BACKGROUND OF THE INVENTION

Searching databases typically involves using structured or unstructuredsearches on large compilations of data, with some rudimentaryfield-specific search functionality.

SUMMARY OF THE INVENTION

A system for database access is disclosed that includes a plurality ofdatabases, where each database has a plurality of defined data fields. Amapping system is configured to create an algorithmic relationshipbetween a plurality of first fields of a plurality of first databases,and a corresponding field of a plurality of second fields of a pluralityof second databases. In this manner, changes made to one database can bepromulgated to the other databases.

Other systems, methods, features, and advantages of the presentdisclosure will be or become apparent to one with skill in the art uponexamination of the following drawings and detailed description. It isintended that all such additional systems, methods, features, andadvantages be included within this description, be within the scope ofthe present disclosure, and be protected by the accompanying claims.

BRIEF DESCRIPTION OF THE SEVERAL VIEWS OF THE DRAWINGS

Aspects of the disclosure can be better understood with reference to thefollowing drawings. The components in the drawings may be to scale, butemphasis is placed upon clearly illustrating the principles of thepresent disclosure. Moreover, in the drawings, like reference numeralsdesignate corresponding parts throughout the several views, and inwhich:

FIG. 1 is a diagram of system for providing database mappingfunctionality, in accordance with an example embodiment of the presentdisclosure;

FIG. 2 is a diagram of system for mapping fields between differentdatabases, in accordance with an example embodiment of the presentdisclosure;

FIG. 3 is a diagram of algorithm for providing product update mappingfunctionality, in accordance with an example embodiment of the presentdisclosure; and

FIG. 4 is a diagram of algorithm for providing product search mappingfunctionality, in accordance with an example embodiment of the presentdisclosure.

DETAILED DESCRIPTION OF THE INVENTION

In the description that follows, like parts are marked throughout thespecification and drawings with the same reference numerals. The drawingfigures may be to scale and certain components can be shown ingeneralized or schematic form and identified by commercial designationsin the interest of clarity and conciseness.

The functional aspects of the present disclosure include a reliable andeffective product and social media post search tool, such as for use bysocial media posters and their followers or for users that are lookingfor products. The social media posts are a form of contextualized mediathat can include static imagery, videos and other data, and can haveassociated metadata, including commerce-related metadata that it is usedto provide rich search results, such as to allow a user to identifyspecific products of interest. For example, the present disclosure canbe used to provide a keyword search that returns contextual mediaresults that can be used in an associated commercial transaction, suchas shopping. The contextual media has associated metadata that canidentify products that are presently available for purchase that areassociated with the presented contextual media, or other suitablemetadata. In this embodiment, the associated metadata does not providethe context, and instead, can be a function of the context, as discussedfurther herein. The present disclosure thus provides substantially morethan prior art search tools that are used to search individualdatabases, because different databases can be accessed by the socialmedia posters and their followers in a single search. The presentdisclosure thus allows such dynamic database interactions to beaccommodated. The present disclosure provides a number of practicalapplications and technical features.

One practical application of the present disclosure is a product-relatedsearch service that operates on a processor and that includes algorithmsthat provide the ability to create, read, update and delete products aswell as to search products. These algorithmic functions are coordinatedacross multiple databases and are structured to maintain data integrityacross those databases, as disclosed and discussed herein. In oneexample embodiment, a database can include data associated with aspecific social media, such as metadata for tagged items within thesocial media post, where the structure of the tags and associated itemswithin the social media post also forms part of the data. In thisembodiment, the placement of a tag, image data associated with the tagand metadata associated with the tag can form different fields ormultiple different fields within the database for that social mediasource. Mapping of such social media post database content to otherdatabases can be performed by a dedicated mapping system that can beimplemented on a processor by one or more algorithms that are configuredto perform field to field mapping, post to field mapping, tag to fieldmapping, metadata to field mapping, image data to field mapping or othersuitable types of mapping. These algorithms can include definedrelationships between fields, posts, tags, metadata and so forth, wherethe relationships can be identified by a programmer, identified usingartificial intelligence or otherwise identified, but can be implementedin an algorithm to accelerate the execution of the algorithms and toallow complex relationships to be created. Thus, the present disclosureprovides a system that allows a user to 1) find relevant fields indiverse databases, 2) compare the content of the fields to determinerelevancy, and 3) create mapping relationships for future automatedapplications. Likewise, mapping of multiple different types of socialmedia data fields can also or alternatively be performed, such as postto post mapping, tag to tag mapping, metadata to metadata mapping, imagedata to image data mapping or other suitable types of mapping.

A system and method in accordance with the teachings of the presentdisclosure can also include integration of product search with aninternal product database, website tools, web log (“blog”) tools, socialmedia tools and so forth. These tools are algorithms that assist withthe creation of content, and allow the user to include product-relateddata in the content that is up to date and accurate. This integrationincludes the ability to limit the search to one or more differentdatabases or other sources, such as to search an internal productdatabase and a social media post database to determine how social mediaposts present product data and to compare that with the internal productdatabase information, and for other suitable purposes.

A system and method in accordance with the teachings of the presentdisclosure can also add a product schema that is applicable to each ofthe databases (such as rules, selectors and scraping) and data migrationtools that are compatible with the different databases. The presentdisclosure thus allows data to be easily transferred between andutilized within the various databases.

Each database can have a different structure and can have a separate anddistinct search functionality. The searches can be nested and orderedbased on the search rules and functionality for each data source. Inthis manner, the results of the search can differ based on the order inwhich the databases are searched and the search terms and structure usedfor each database.

In one example embodiment, searches can have a first optimal searchorder, where search inputs to database 1 are different from searchinputs to database 2, and where the search sequence uses a first set ofinputs to database 1, and then uses the results from that search toselect inputs to database 2, which can provide different results than asearch sequence where a second set of inputs is provided to database 2,and where those results are used to select inputs to database 1, and soforth for additional databases. In the example discussed above, a searchstarting with a first social media database that includes image data,tags and metadata that is mapped to a second non-social media databasethat contains separate fields such as columns and rows and which is thenmapped to a third social media database can return different resultsthan a search that starts with the non-social media database and that isthen mapped to the first social media database and the second socialmedia database. For example, a search for the term “black hat” in thefirst social media database can result in associated product names thatcan be mapped to many different black hat products in a non-social mediaproduct database, which can then be used to find those specific productsin the second social media database that have associated product namesand SKU numbers, such as where the second social media database does notinclude the term “black hat” but includes product names for some entriesand SKU numbers for other entries. In this example embodiment, a searchfor black hats in the second social media database would not produce anymeaningful results, and a search for SKU numbers in the first socialmedia database would likewise not produce any meaningful results, butthe disclosed structured database search can be used to provideadditional functionality that is not present in any one of the threeseparate databases.

In another example embodiment, the databases can include data structuresdisclosed in U.S. Pat. Nos. 9,779,425; 9,875,488; and 9,495,693; U.S.patent application Ser. Nos. 15/842,026; 15/211,321; 13/905,926;13/838,578 and 13/547,771, each of which are hereby incorporated byreference for all purposes as if set forth herein in their entireties,or other suitable databases.

A system and method in accordance with the teachings of the presentdisclosure can also modify existing database-specific access tools basedon the product schema and the access rules for accessing multipledatabases. For example, when a user updates a product description in onedatabase, such as in a blog post or a product inventory database, thepresent disclosure can allow those updates to be promulgated to otherdatabases, such as when a predefined algorithmic relationship has beendefined between the field by the user and the other database fields. Inthis embodiment, a user that updates a product description in a blogpost can be presented with the product description in a productinventory database, and can either use that description for the blogpost, or modify that description if it is incorrect in the productinventory database. That updated product inventory database descriptioncan then be updated in other database entries that have beenalgorithmically associated with the data field.

A system and method in accordance with the teachings of the presentdisclosure can also modify a database to include a product schema thatis structured in that products that are searched will have a timerelevancy parameter. In one example embodiment, newer products that areadded into any of the databases can get priority viewing, products thatare trending in sales (sales time relevancy) can get priority viewing,and so forth.

A system and method in accordance with the teachings of the presentdisclosure can also provide additional capabilities that can be includedin a “like to know it” social media post search function, for a databasewhere users have provided an indication of interest in response tosocial media posts. For example, the system and method can provide theability to dynamically curate the content to not display items that aresold out or no longer sold, such as by cross-referencing social mediaposts as a function of one or more products that are identified in thesocial media post. The ability to leverage clicks from searches toincrease relevancy can also be provided, such as to increase a relevancyscore for a social media post in response to a search term based on thenumber of times that social media post is selected in response to asearch, the number of times that a purchase or click through event ismade from that social media post, or in other suitable manners. Ingeneral, the relevancy functionality allows consumer behavioral patternsto be tracked and used to leverage the relevancy of social media posts,and can be applied to any of the subsystems discussed herein, even ifnot specifically address in regards to each subsystem for the sake ofbrevity.

The ability to add metadata to images in order to create more relevantdescriptions can also be provided, including but not limited to imagesfor social media posts and images for products that are available fromdifferent websites. The metadata can be added manually (such as inresponse to a social media viewer's selection of content or addition ofsearch terms), automatically (such as to apply modifications made tometadata in a first database to related data in other databases) or inother suitable manners. Default options can be provided with a list ofadditional options that are generated as a function of what has beensearched, the results of the search and the actions and inactions takenby a user in response to the search results, including selection ofsearch results and content within search results, to add additionalmetadata to images and so forth.

A field can be added in one or more of the databases to take intoaccount predefined metadata such as “hash tags” made by the social mediaposters, as a separate searchable field. An “ignore list” can also beprovided to allow predetermined fields, certain data within certainfields or other suitable database content to be ignored as a function ofdatabase or database entry point. For example, if a search is beingconducted for the term “shoe,” social media posts by a user having aname that includes “shoe” such as “shoemaker,” stores that have a namethat includes “shoe” and other fields that are not of interest can beselected and excluded by a user. In one example embodiment, the ignorelist functionality can be dynamic, and a user can be presented with apreliminary identification of fields that include the term and canexclude fields that should not be included. Likewise, relevancy data canbe provided, such as to identify the fields where the term is most andleast likely to be used, and so forth.

A “popular search” functionality can be provided that utilizes a manualapproach (such as where a user requests popular searches for fields orterms), an automatic approach (such as where popular searches related toa search term are presented), or other suitable popular searchfunctions. An “auto-complete” functionality that can present othersearch phrases that have been used previously by the same user ordifferent users can also be provided. In one example embodiment, theauto complete function can be modified based on search history, popularsearches, trending searches or in other suitable manners.

The ability to provide “did you mean” functionality which uses theresults of past searches to help narrow search results in order to helpusers find what they are looking for can be provided. In one exampleembodiment, the user can search for the term “black tie” and the searchfunction can prompt the user to identify whether they meant a black tieproduct, a black tie event or something else. The ability to provide areal time search index can also be provided, which can update the dataevery time that an influencer makes a social media post, every time anew product entry is created or in other similar manners.

The ability to find “similar” results to a product or social media post,to use a “reverse” search method against the search conditions togenerate a given result can also be provided. For example, “similar”results can be similar in a number of different ways, such as similarityto different fields in different databases for a number of differentfields associated with a product or social media post. Use of imageanalysis to improve search and to find new items can also be provided.In one example embodiment, an image can be analyzed to identify aplurality of different field identifiers, which can be used tosupplement or confirm other field identifiers. For example, an image canhave a field identifier of “shirt” but not of “hat,” but the image canbe selected in response to search results for the search term “shirt andhat.”

FIG. 1 is a diagram of system 100 for providing database mappingfunctionality, in accordance with an example embodiment of the presentdisclosure. System 100 includes social media post 102, which furtherincludes products 104A and 104B, product descriptions 106A and 106B,product images 108A and 108B, scene description 110 and internal data112. System 100 further includes database 116 with fields 1 through 6,and mapping system 114. System 100 can be implemented in hardware or asuitable combination of hardware and software.

Social media post 102 is data stored in defined memory locations andadditional algorithmic functionality that is configured to allow aprocessor to generate a user display that includes the identified datafields. In one example embodiment, social media post can includepredetermined user controls that allow a user to select hyperlinks orother controls contained within social media post 102, such as tonavigate to other content, to open a web browser user interface window,to add a post or to perform other suitable functions. The data fields ofsocial media post 102 can be implemented as part of the algorithmicfunctionality or in other suitable manners.

Products 104A and 104B are defined data fields that include a productname, a product identification number, a product catalog number, aproduct part number or other product data that can be used to locate theproduct and uniquely identify the product. In this regard, the uniqueidentification can be limited to uniquely identifying the product withinsocial media post 102, such as “black hat” when social media post 102includes a product image of a black hat and a white hat, “large blackhat” when social media post 102 includes a product image of a large anda small black hat, and other suitable product identifying data. Also oralternatively, products 104A and 104B can include a product catalognumber, a stock keeping unit number or SKU, a part number or othersuitable data or combinations of data.

Product descriptions 106A and 106B are data fields that include auser-description of products 104A and 104B, such as a description of thefabric or material that the products are made from, a description of theintended use of the product or other suitable description product data.In one example embodiment, product descriptions 106A and 106B caninclude a hyperlink to a different database, can provide one or morehyperlinks for use by other databases or can include other suitabledata.

Product images 108A and 108B can be one or more sets of image data thatare associated with products 104A and 104B and product descriptions 106Aand 106B. In one example embodiment, product images 108A and 108B can becontained within the same set of image data, can be separate sets ofimage data, can be a first set of image data that includes images ofboth products 104A and 104B and a second set and a third set of imagedata that include corresponding separate images of each product 104A and104B, or other suitable image data. One or more sets of image dataassociated with product images 108A and 108B can also or alternativelyinclude a hyperlink to a different image database, can provide one ormore hyperlinks for use by other image databases or can include othersuitable data.

Scene description 110 can be a text or other suitable description of ascene that includes products 104A and 104B, such as a description of theevent or location where product images 108A and 108B where obtained, adescription of events or locations where products 104A and 104B can beused, or other suitable data. In one example embodiment, scenedescription 110 can include a social media post that has been made by anauthor associated with social media post 102, such as the personassociated with the social media account where social media post 102 wascreated. In this regard, it is noted that social media post 102 can becreated prior to actual posting on a social media application orwebsite, such as where social media post 102 will be processed into asingle image data set or other suitable data sets, and where thecomponents of social media post 102 are not directly accessible, such asa Facebook post, an Instagram post, a blog post or other suitable socialmedia posts. Also or alternatively, the components of social media post102 can be separately stored in a social media database of a socialmedia application or website, such as a Facebook post, an Instagrampost, a blog post or other suitable social media posts.

Internal data 112 can be a data field that is contained within scenedescription 110 or other data fields (such as products 104A or 104B,product descriptions 106A or 106B, product images 108A or 108B and soforth). In one example embodiment, internal data 112 can be identifiedusing a predetermined character, such as a hash tag (“#”), apredetermined sequence of characters or other suitable data. In anotherexample embodiment, internal data 112 can be an image data watermark orother suitable data that is used to uniquely identify data afterprocessing the data with a predetermined algorithm, such as an opticalcharacter recognition algorithm, a watermark detection algorithm or soforth. Internal data 112 can be correlated with one or more of product104A or 104B, product description 106A or 106B, product image 108A or108B, scene description 110 or other suitable data, can be independentof any other data or other suitable correlations or associations canalso or alternatively be used.

Database 116 and fields 1 through 6 can be a relational database, adocument-oriented database, an operational database, a distributeddatabase, a cloud database, an object database, a column-orienteddatabase, a key value database or other suitable databases that containexisting data sets, empty data sets, alphanumeric data sets, image datasets or other suitable types of data. Mapping system 114 can include oneor more predefined or user-defined associations between fields 1 through6 of database 116 and one or more of products 104A or 104B, productdescriptions 106A or 106B, product images 108A or 108B, scenedescription 110, internal data 112 or other suitable data. Although asingle database 116 is shown, additional databases can also oralternatively have fields that are mapped by mapping system 114, such asto create algorithmic rules for associating data fields, posts,hyperlinks, tags or other suitable data in a first database or systemwith data fields, posts, hyperlinks, tags or other suitable data in oneor more second databases or systems. The number and sequence ofalgorithmic mapping relationships is flexible, and can include differentmapping relationships for the same field of social media post 102 todifferent fields of different databases, different mapping relationshipsbetween different databases to social media post 102, mappingrelationships between social media post 102 and other social mediaposts, or other suitable algorithmic mapping relationships. Fields 1through 6 are an example embodiment, and any suitable number of fieldscan also or alternatively be used.

In operation, system 100 allows social media post 102 to be mapped tofields 1 through 6 of database 116 through mapping system 114, and canprovide additional mapping functionality between other social mediaposts, other databases, other types of social media and other types ofdatabases, or other suitable mapping functionality. System 100 allowsuser-defined algorithms, predefined algorithms or other algorithmicfunctionality to be implemented to facilitate mapping of data andfields.

FIG. 2 is a diagram of system 200 for mapping fields between differentdatabases, in accordance with an example embodiment of the presentdisclosure. System 200 includes mapping system 114 and social media postdatabase 202, internal product database 204, blog database 206, websitedatabase 208, multiple database search system 210, data migration system212, product schema system 214, database modification system 216 andsearch index system 218, each of which can be implemented in hardware ora suitable combination of hardware and software.

Social media post database 202 includes data from one or more socialmedia posts. In one example embodiment, social media post database 202can be maintained by a social media website, but can also oralternatively be maintained by a third party organization that providessupport to users of a social media website. Social media post database202 can include one or more data fields that are defined and associatedwith social media posts, such as product identifiers, productdescriptions, product images, scene descriptions, internal data andother suitable data fields, either in a relational database or othersuitable databases.

Internal product database 204 includes data for each of a plurality ofproducts. In one example embodiment, internal product database 204 canbe maintained by a manufacturer, wholesale sales organization, retailsales organization or other suitable organizations, but can also oralternatively be maintained by a third party organization that providessupport to manufacturers or sales organizations. Internal productdatabase 204 can include one or more data fields that are defined andassociated with products, such as product identifiers, productdescriptions, product images, internal data and other suitable datafields, either in a relational database or other suitable databases.

Blog database 206 includes data for each of a plurality of website logentries. In one example embodiment, blog database 206 can be maintainedby a website log services provider, but can also or alternatively bemaintained by a third party organization that provides support towebsite log services providers. Blog database 206 can include one ormore data fields that are defined and associated with products, such asproduct identifiers, product descriptions, product images, internal dataand other suitable data fields, either in a relational database or othersuitable databases.

Website database 208 includes data for each of a plurality of websiteservice providers. In one example embodiment, website database 208 canbe maintained by a website commerce services provider, but can also oralternatively be maintained by a third party organization that providessupport to website commerce services providers. Website database 208 caninclude one or more data fields that are defined and associated withproducts, such as product identifiers, product descriptions, productimages, internal data and other suitable data fields, either in arelational database or other suitable databases.

Multiple database search system 210 can include one or more algorithmsoperating on a general purpose processor or other suitable systems thatare configured to generate a user prompt to enter a search term andassociated search commands, and to search multiple databases using thesearch term and associated search commands. In one example embodiment,multiple database search system 210 can receive a product query with oneor more terms or identifiers, and can return database search resultsfrom multiple unrelated databases that include the terms or identifiers,where the database search results include products and associatedproduct data, such as images, descriptions and so forth. In anotherexample embodiment, a series of database queries can be identified, suchas where a product database for a retailer is searched first usingdescriptive product terms (such as “black hat” or “grey slacks”) toobtain product catalog numbers, and where a database of social mediaposts is then searched using the product catalog numbers, by using thedescriptive product terms and the product catalog numbers or in othersuitable manners. In another example embodiment, descriptive productterms can be used to search a plurality of first databases, such asretail website sales databases, and the results can be used to generatean ordered list that is sorted by sales information. A user can thenselect one or more entries from the list, and the results can be used tosearch a plurality of social media databases, where the results can beused to generate an ordered list that is sorted by a relevance metric,such as a number of views, “likes” or other indicators of relevance.Likewise, other suitable multiple database search sequencing and resultsdisplay functionality can also or alternatively be provided.

Data migration system 212 can include one or more algorithms operatingon a general purpose processor or other suitable systems that areconfigured to generate a user prompt to display mapped fields from twoor more databases and to create data migration relationships between thefields. In one example embodiment, a user can review a productdescription field from a product database and a product descriptionfield from a social media post, and can activate a control to create adata migration relationship between the two fields, such as to make thesocial media post dependent on the product database, to make the productdatabase dependent on the social media post or in other suitableembodiments. In another example embodiment, product description fieldsfrom a plurality of social media posts can be made dependent on aproduct description field in a product database, a plurality ofdifferent product description fields in a plurality of social mediaposts, blog posts, websites and other databases can be made dependent onone or more product description fields in a products database, or othersuitable functions can also or alternatively be provided.

Product schema system 214 can include one or more algorithms operatingon a general purpose processor or other suitable systems that areconfigured to generate a product schema for one or more databases. Inone example embodiment, a product schema can be used to associate socialmedia posts, blogs, textual data, image data sets or other suitable datawith other related data. In this example embodiment, a schema caninclude larger classes (e.g. men, women, children), and successivenarrower classes in each product class (e.g. pants, shirts, shoes, andthen sizes, colors, fabric and so forth). Product schema system 214 canmodify a database structure to include the product schema, such as bygenerating one or more user prompts for a user to select fields to beassociated with a schema, to associate the schema with the existingdatabase fields or in other suitable manners. In another embodiment,relevance data can be used to select entries for review by a user, suchas to ensure that products or posts that have a predetermined level ofrelevancy are reviewed to ensure that the data is correct. In thisexample embodiment, a user can be notified that a social media post orother data has been viewed a predetermined number of times, apredetermined number of times during a period of time, that the numberof view per unit of time is increasing or of other suitable data, andthe user can review the data and associated data in other databases toensure that the schema associate with the data is consistent, such as toprovide prompt correction in the case of inconsistencies.

Database modification system 216 can include one or more algorithmsoperating on a general purpose processor or other suitable systems thatare configured to generate a user prompt to modify a database structure.In one example embodiment, a database field can be added or merged withanother database field, a selected group of database fields can bedeleted and replaced with other database fields, mapped associations orhyperlinks can be created that define an association between databasefields within a database or other suitable algorithmic structures orfunctions can be implemented. In another embodiment, relevance data canbe used to select entries for review by a user, such as to ensure thatproducts or posts that have a predetermined level of relevancy arereviewed to ensure that the data is correct. In this example embodiment,a user can be notified that a social media post or other data has beenviewed a predetermined number of times, a predetermined number of timesduring a period of time, that the number of view per unit of time isincreasing or of other suitable data, and the user can review the dataand associated data in other databases to ensure that it is consistent,such as to provide prompt correction in the case of inconsistencies.

Search index system 218 can include one or more algorithms operating ona general purpose processor or other suitable systems that areconfigured to generate a user prompt to enter a search term andassociated search commands, and to generate a search index for one ormore databases. In one example embodiment, the search index can includealgorithmic functionality that dynamically creates and supplements anindex with each successive search. In this example embodiment, a searchfor the term “black hat” in a database of social media posts cangenerate a number of hits, and the search index can be incremented forthe total number of hits, for the hits associated with the term, thehits associated each social media post and so forth. Search index system218 can generate a stand-alone search index, can create a databasestructure for storing the search index in each searched database orother suitable functions can also or alternatively be implemented.

In operation, system 200 allows data fields in different databases to beassociated with each other to improve the ability to search eachdatabase and the uniformity of the contents of each database. System 200thus provides practical applications for improving the ability toidentify products in different databases, to ensure that the productsare the same, to track the search results of searches for products andother functions that are substantially more than the current knownsystems and processes that only allow individual searches to beperformed of separate databases.

FIG. 3 is a diagram of algorithm 300 for providing product updatemapping functionality, in accordance with an example embodiment of thepresent disclosure. Algorithm 300 can be implemented in hardware or asuitable combination of hardware and software, and can operate on one ormore processor platforms.

Algorithm 300 begins at 302, where product and database identifiers arereceived. In one example embodiment, the algorithm can generate a userinterface control that allows a user to select from a list of availabledatabases, and to enter a product identifier, a product name, or othersuitable product data. The algorithm then proceeds to 304.

At 304, the product and database identifier data is processed with amapping system. In one example embodiment, the mapping system can searchone or more fields in each of the identified databases using the productdata, such as by searching each database in parallel, by performing aseries of searches where a first database is searched (such as a socialmedia post database) and where the results from the first database arethen used to search a second database (such as a product database).Likewise, additional searches or series of searches can also oralternatively be performed. The algorithm then proceeds to 306.

At 306, it is determined whether the product is in the identifieddatabases. If it is determined that the product is in the identifieddatabases, the algorithm proceeds to 310, otherwise the algorithmproceeds to 308.

At 308, the product is added to the databases. In one exampleembodiment, a search can identify a product in a first database (such asa social media post database) but not in a second database (such as aproduct database). In this example embodiment, the product can be addedto the product database, with additional information that might beincluded in that database but which might not be present in the socialmedia post database, such as product descriptions, catalog numbers andso forth.

At 310, the results from the databases are displayed. In one exampleembodiment, predetermined fields from a first database can be displayedadjacent to predetermined fields from a second database, such as productdescription fields, catalog number fields and so forth. The algorithmthen proceeds to 312.

At 312, it is determined whether the data should be modified. If it isdetermined that the data should be modified, the algorithm proceeds to314, otherwise the algorithm proceeds to 316.

At 314, the databases are edited. In one example embodiment, a productdescription field from a product database can be used to supplement orreplace product description data in a social media post, such as bydeleting the product description data from the social media post andadding the product description data to the social media database, byincluding a hyperlink to the product database from the social mediapost, or in other suitable manners.

At 316, it is determined whether the data should be deleted. If it isdetermined that the data should be deleted, the algorithm proceeds to318, otherwise the algorithm proceeds to 320 and terminates. At 318, thedata is deleted from the databases. In one example embodiment, the datafor a single field can be deleted, data for a group of fields in one ormore databases can be deleted and replaced with a hyperlink to thefields of a second database or other suitable processes can also oralternatively be used.

In operation, algorithm 300 allows data in multiple databases to beedited and coordinated, to provide the practical application ofimproving the consistency of search results and the accuracy of data inmultiple databases. Algorithm 300 provides substantially more than theprior art by allowing related data in different databases to be readilyidentified and added, edited or deleted. Although algorithm 300 is shownas a flow chart, the functions of algorithm 300 can also oralternatively be implemented as objected oriented programming, using astate diagram or in other suitable manners.

FIG. 4 is a diagram of algorithm 400 for providing product searchmapping functionality, in accordance with an example embodiment of thepresent disclosure. Algorithm 400 can be implemented in hardware or asuitable combination of hardware and software, and can operate on one ormore processor platforms.

Algorithm 400 begins at 402, where a product search request is received.In one example embodiment, the algorithm can generate one or more usercontrols that prompt a user to enter a search query for a product, acatalog number or other suitable data. The algorithm then proceeds to404.

At 404, the product search data is processed with a mapping system. Inone example embodiment, a user can be looking for products of a certaintype, such as a “black hat.” The product description term “black hat”can be mapped to product databases and to social media posts by themapping system, to identify posts products from product databases thatare “black hats” and to identify social media posts that show picturesof “black hats” with other clothing. Likewise, other functions can alsoor alternatively be provided. The algorithm then proceeds to 406.

At 406, it is determined whether the product is in any databases. If theproduct is not in any databases, the algorithm proceeds to 408,otherwise the algorithm proceeds to 410.

At 408, a notice is provided to the user that the product was not found,and the user can refine their search. In one example embodiment, searchsuggestions can be provided, such as for products that have similarspellings, similar sounding names or in other suitable manners.Likewise, lists of the user's previous searches, the most recentsearches from other users, the most popular searches or other suitabledata can be generated by the algorithm, to assist the user.

At 410, it is determined whether the product is in stock. In one exampleembodiment, it can be determined whether the product is locallyavailable, is out of stock but on back order, is available from otherretailers, has been discontinued by the manufacturer, or other suitablestatus data can be determined. If it is determined that the product isnot in stock, the algorithm proceeds to 412, otherwise the algorithmproceeds to 414.

At 412, a notice is provided to the user that the product is out ofstock, and the user can refine their search. In one example embodiment,search suggestions can be provided, such as for similar products thatare in stock, or in other suitable manners.

At 414, the results are ranked. In one example embodiment, results canbe ranked based on a number of times that a product has been identifiedin response to a search, such as for social media posts that include theproduct and other products, based on an amount of commercial activityassociated with the social media post or in other suitable manners. Thealgorithm then proceeds to 416, where the ranked results are displayed.

In operation, algorithm 400 allows data in multiple databases to besearched in response to a query, to provide the practical application ofimproving the consistency of search results and the ability to find dataof interest to the user. Algorithm 400 provides substantially more thanthe prior art by allowing related data in different databases to bereadily identified and displayed, and for the most pertinent data forproduct related searches to be displayed, such as data that shows howthe product looks and what it can be combined with. Although algorithm400 is shown as a flow chart, the functions of algorithm 400 can also oralternatively be implemented as objected oriented programming, using astate diagram or in other suitable manners.

As used herein, the singular forms “a”, “an” and “the” are intended toinclude the plural forms as well, unless the context clearly indicatesotherwise. It will be further understood that the terms “comprises”and/or “comprising,” when used in this specification, specify thepresence of stated features, integers, steps, operations, elements,and/or components, but do not preclude the presence or addition of oneor more other features, integers, steps, operations, elements,components, and/or groups thereof. As used herein, the term “and/or”includes any and all combinations of one or more of the associatedlisted items. As used herein, phrases such as “between X and Y” and“between about X and Y” should be interpreted to include X and Y. Asused herein, phrases such as “between about X and Y” mean “between aboutX and about Y.” As used herein, phrases such as “from about X to Y” mean“from about X to about Y.”

As used herein, “hardware” can include a combination of discretecomponents, an integrated circuit, an application-specific integratedcircuit, a field programmable gate array, or other suitable hardware. Asused herein, “software” can include one or more objects, agents,threads, lines of code, subroutines, separate software applications, twoor more lines of code or other suitable software structures operating intwo or more software applications, on one or more processors (where aprocessor includes one or more microcomputers or other suitable dataprocessing units, memory devices, input-output devices, displays, datainput devices such as a keyboard or a mouse, peripherals such asprinters and speakers, associated drivers, control cards, power sources,network devices, docking station devices, or other suitable devicesoperating under control of software systems in conjunction with theprocessor or other devices), or other suitable software structures. Inone exemplary embodiment, software can include one or more lines of codeor other suitable software structures operating in a general purposesoftware application, such as an operating system, and one or more linesof code or other suitable software structures operating in a specificpurpose software application. As used herein, the term “couple” and itscognate terms, such as “couples” and “coupled,” can include a physicalconnection (such as a copper conductor), a virtual connection (such asthrough randomly assigned memory locations of a data memory device), alogical connection (such as through logical gates of a semiconductingdevice), other suitable connections, or a suitable combination of suchconnections. The term “data” can refer to a suitable structure forusing, conveying or storing data, such as a data field, a data buffer, adata message having the data value and sender/receiver address data, acontrol message having the data value and one or more operators thatcause the receiving system or component to perform a function using thedata, or other suitable hardware or software components for theelectronic processing of data.

In general, a software system is a system that operates on a processorto perform predetermined functions in response to predetermined datafields. A software system is typically created as an algorithmic sourcecode by a human programmer, and the source code algorithm is thencompiled into a machine language algorithm with the source codealgorithm functions, and linked to the specific input/output devices,dynamic link libraries and other specific hardware and softwarecomponents of a processor, which converts the processor from a generalpurpose processor into a specific purpose processor. This well-knownprocess for implementing an algorithm using a processor should requireno explanation for one of even rudimentary skill in the art. Forexample, a system can be defined by the function it performs and thedata fields that it performs the function on. As used herein, a NAMEsystem, where NAME is typically the name of the general function that isperformed by the system, refers to a software system that is configuredto operate on a processor and to perform the disclosed function on thedisclosed data fields. A system can receive one or more data inputs,such as data fields, user-entered data, control data in response to auser prompt or other suitable data, and can determine an action to takebased on an algorithm, such as to proceed to a next algorithmic step ifdata is received, to repeat a prompt if data is not received, to performa mathematical operation on two data fields, to sort or display datafields or to perform other suitable well-known algorithmic functions.Unless a specific algorithm is disclosed, then any suitable algorithmthat would be known to one of skill in the art for performing thefunction using the associated data fields is contemplated as fallingwithin the scope of the disclosure. For example, a message system thatgenerates a message that includes a sender address field, a recipientaddress field and a message field would encompass software operating ona processor that can obtain the sender address field, recipient addressfield and message field from a suitable system or device of theprocessor, such as a buffer device or buffer system, can assemble thesender address field, recipient address field and message field into asuitable electronic message format (such as an electronic mail message,a TCP/IP message or any other suitable message format that has a senderaddress field, a recipient address field and message field), and cantransmit the electronic message using electronic messaging systems anddevices of the processor over a communications medium, such as anetwork. One of ordinary skill in the art would be able to provide thespecific coding for a specific application based on the foregoingdisclosure, which is intended to set forth exemplary embodiments of thepresent disclosure, and not to provide a tutorial for someone havingless than ordinary skill in the art, such as someone who is unfamiliarwith programming or processors in a suitable programming language. Aspecific algorithm for performing a function can be provided in a flowchart form or in other suitable formats, where the data fields andassociated functions can be set forth in an exemplary order ofoperations, where the order can be rearranged as suitable and is notintended to be limiting unless explicitly stated to be limiting.

It should be emphasized that the above-described embodiments are merelyexamples of possible implementations. Many variations and modificationsmay be made to the above-described embodiments without departing fromthe principles of the present disclosure. All such modifications andvariations are intended to be included herein within the scope of thisdisclosure and protected by the following claims.

What is claimed is:
 1. A system for database access comprising: aplurality of databases comprising: a social media post databaseincluding a plurality of data fields associated with one or more socialmedia posts; a product database including a plurality of data fieldsassociated with one or more products; and at least one processor coupledto the plurality of databases, the at least one processor configured to:create an algorithmic relationship between the plurality of data fieldsof the social media post database and the plurality of data fields ofthe product database, wherein creating the algorithmic relationshipfurther comprises creating a data migration relationship between a firstdata field of the social media post database and a corresponding seconddata field of the product database, the data migration relationshipcausing the social media post database to be dependent on the productdatabase; generate a product schema for the social media post databaseand the product database; modify a database structure of the socialmedia post database and the product database to include the productschema; receive product data from a user; using one or more descriptiveproduct terms based on the product data, search the plurality of datafields of the product database to obtain one or more product catalognumbers; using the one or more product catalog numbers and/or the one ormore descriptive product terms, search the plurality of data fields ofthe social media post database to identify one or more posts associatedwith the one or more product catalog numbers and/or the one or moredescriptive product terms; compare the identified one or more posts withone or more products in the product database that are associated withthe one or more product catalog numbers; determine, based on thecomparison, whether to modify one or more data fields in the socialmedia post database and/or the product database; and modify, based onthe determining, the one or more data fields in the social media postdatabase, the modifying including deleting at least one data fieldcontent of the one or more data fields of the social media post databaseand replacing the at least one data field content with a hyperlink tothe one or more data fields in the product database.
 2. The system ofclaim 1 wherein the plurality of data fields of the social media postdatabase and the product database comprise product identifier fields,product description fields and product image fields, wherein the socialmedia post database further includes contextualized media and associatedmetadata, and wherein the at least one processor is further configuredto: receive one or more user-entered search terms from the user; andreturn the contextualized media and the associated metadata to the user.3. The system of claim 1 wherein the product database is associated witha merchant, and wherein the plurality of data fields of the productdatabase and the social media post database comprise product identifierfields, product description fields and product image fields.
 4. Thesystem of claim 1 wherein the product database is associated with awebsite provider, and wherein the plurality of data fields of theproduct database and the social media post database comprise productidentifier fields, product description fields and product image fields.5. The system of claim 1, wherein the at least one processor is furtherconfigured to apply the product schema to the plurality of data fieldsof the product database, and the corresponding plurality of data fieldsof the social media post database.
 6. The system of claim 1, wherein theat least one processor is further configured to: automatically modifythe algorithmic relationship between the modified one or more datafields and other data fields of the social media post database.
 7. Thesystem of claim 1, wherein the at least one processor is furtherconfigured to: receive the plurality of data fields of the productdatabase and the plurality of data fields of the social media postdatabase; and generate a search index from the plurality of receiveddata fields.
 8. A method for providing database access using a systemcomprising at least one processor coupled to a plurality of databases,the plurality of databases comprising (i) a social media post databaseincluding a plurality of data fields associated with one or more socialmedia posts and (ii) a product database including a plurality of datafields associated with one or more products, the method comprising:creating an algorithmic relationship between the plurality of datafields of the social media post database and the plurality of datafields of the product database, wherein creating the algorithmicrelationship further comprises creating a data migration relationshipbetween a first data field of the social media post database and acorresponding second data field of the product database, the datamigration relationship causing the social media post database to bedependent on the product database; generating a product schema for thesocial media post database and the product database; modifying adatabase structure of the social media post database and the productdatabase to include the product schema; receiving product data from auser; using one or more descriptive product terms based on the productdata, searching the plurality of data fields of the product database toobtain one or more product catalog numbers; using the one or moreproduct catalog numbers and/or the one or more descriptive productterms, searching the plurality of data fields of the social media postdatabase to identify one or more posts associated with the one or moreproduct catalog numbers and/or the one or more descriptive productterms; comparing the identified one or more posts with one or moreproducts in the product database that are associated with the one ormore product catalog numbers; determining, based on the comparison,whether to modify one or more data fields in the social media postdatabase and/or the product database; and modifying, based on thedetermining, the one or more data fields in the social media postdatabase, the modifying including deleting at least one data fieldcontent of the one or more data fields of the social media post databaseand replacing the at least one data field content with a hyperlink tothe one or more data fields in the product database.
 9. The method ofclaim 8 wherein the plurality of data fields of the social media postdatabase and the product database comprise product identifier fields,product description fields and product image fields, and wherein theproduct database is associated with a website provider.
 10. The methodof claim 8 wherein the plurality of data fields of the social media postdatabase and the product database comprise product identifier fields,product description fields and product image fields, and wherein theproduct database is associated with a merchant.
 11. The method of claim8 wherein the plurality of data fields of the social media post databaseand the product database comprise product identifier fields, productdescription fields and product image fields, wherein the social mediapost database further includes contextualized media and associatedmetadata, and wherein the method further comprises: receiving one ormore user-entered search terms from the user; and returning thecontextualized media and the associated metadata to the user.
 12. Themethod of claim 8 further comprising applying the product schema to theplurality of data fields of the product database and the correspondingplurality of data fields of the social media post database.
 13. Themethod of claim 8 further comprising: automatically modifying thealgorithmic relationship between the modified one or more data fieldsand other data fields of the social media post database.
 14. The methodof claim 8 further comprising: receiving the plurality of data fields ofthe product database and the plurality of data fields of the socialmedia post database; and generating a search index from the plurality ofreceived data fields.
 15. A non-transitory computer-readable mediumstoring computer-executable instructions, which, when executed by atleast one processor coupled to a plurality of databases, the pluralityof databases comprising (i) a social media post database including aplurality of data fields associated with one or more social media postsand (ii) a product database including a plurality of data fieldsassociated with one or more products, cause the at least one processorto perform operations comprising: creating an algorithmic relationshipbetween the plurality of data fields of the social media post databaseand the plurality of data fields of the product database, whereincreating the algorithmic relationship further comprises creating a datamigration relationship between a first data field of the social mediapost database and a corresponding second data field of the productdatabase, the data migration relationship causing the social media postdatabase to be dependent on the product database; generating a productschema for the social media post database and the product database;modifying a database structure of the social media post database and theproduct database to include the product schema; receiving product datafrom a user; using one or more descriptive product terms based on theproduct data, searching the plurality of data fields of the productdatabase to obtain one or more product catalog numbers; using the one ormore product catalog numbers and/or the one or more descriptive productterms, searching the plurality of data fields of the social media postdatabase to identify one or more posts associated with the one or moreproduct catalog numbers and/or the one or more descriptive productterms; comparing the identified one or more posts with one or moreproducts in the product database that are associated with the one ormore product catalog numbers; determining, based on the comparison,whether to modify one or more data fields in the social media postdatabase and/or the product database; and modifying, based on thedetermining, the one or more data fields in the social media postdatabase, the modifying including deleting at least one data fieldcontent of the one or more data fields of the social media post databaseand replacing the at least one data field content with a hyperlink tothe one or more data fields in the product database.
 16. Thenon-transitory computer-readable medium of claim 15, wherein theplurality of data fields of the social media post database and theproduct database comprise product identifier fields, product descriptionfields and product image fields, wherein the social media post databasefurther includes contextualized media and associated metadata, andwherein the instructions cause the at least one processor to performfurther operations including: receiving one or more user-entered searchterms from the user; and return the contextualized media and theassociated metadata to the user.
 17. The non-transitorycomputer-readable medium of claim 15, wherein the instructions cause theat least one processor to perform further operations including:automatically modify the algorithmic relationship between the modifiedone or more data fields and other data fields of the social media postdatabase.